namespace Forging2.DataBase.ZH_IMES
{
    using System;
    using System.Collections.Generic;
    using System.ComponentModel.DataAnnotations;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Data.Entity.Spatial;

    public partial class uex_vtrack_record
    {
        [Key]
        [StringLength(50)]
        public string GID { get; set; }

        [StringLength(50)]
        public string DISPATCH_CODE { get; set; }

        [StringLength(50)]
        public string PRODU_CODE { get; set; }

        [StringLength(100)]
        public string PRODU_NAME { get; set; }

        [StringLength(50)]
        public string LOT_CODE { get; set; }

        [StringLength(50)]
        public string MRL_CODE { get; set; }

        [StringLength(50)]
        public string ORDER_GID { get; set; }

        public int? ORDER_TYPE { get; set; }

        [StringLength(50)]
        public string WORK_ORDER_CODE { get; set; }

        [StringLength(50)]
        public string MAKING_ORDER_CODE { get; set; }

        public int? DIS_CODE_STATE { get; set; }

        public int? PRO_TYPE { get; set; }

        [StringLength(50)]
        public string WORK_CENTER_GID { get; set; }

        public DateTime? PREDICT_DATE { get; set; }

        [StringLength(50)]
        public string WORK_CELL_GID { get; set; }

        [StringLength(50)]
        public string NOW_DAQ { get; set; }

        [StringLength(50)]
        public string NOW_DAQ_ID { get; set; }

        public DateTime? NOW_DAQ_DATE { get; set; }

        [StringLength(50)]
        public string NEXT_DAQ { get; set; }

        public DateTime? NEXT_DAQ_DATE { get; set; }

        [StringLength(50)]
        public string FREEZE_LOCATION { get; set; }

        public DateTime? FREEZE_DATE { get; set; }

        [StringLength(500)]
        public string REASON { get; set; }

        [StringLength(1)]
        public string DISPOSE_TYPE { get; set; }

        [StringLength(50)]
        public string DISPOSE_CONTENT { get; set; }

        public int KPART_FLAG { get; set; }

        public int? ORDER_STATE { get; set; }

        public int? OPERATE_STATE { get; set; }

        public int? WORK_ORDER_STATE { get; set; }

        public int? PLAN_QTY { get; set; }

        [StringLength(50)]
        public string ROUTE_CODE { get; set; }

        public int? ROUTE_VERSION { get; set; }

        [StringLength(50)]
        public string ROUTE_GID { get; set; }

        public DateTime? PLANNED_START_TIME { get; set; }

        public DateTime? PLANNED_FINISH_TIME { get; set; }

        public DateTime? UNFREEZE_DATE { get; set; }

        [StringLength(50)]
        public string UNFREEZE_LOCATION { get; set; }

        [StringLength(50)]
        public string FREEZE_ID { get; set; }

        [StringLength(50)]
        public string UNFREEZE_ID { get; set; }

        [StringLength(1)]
        public string ISCOMPLETE { get; set; }

        public DateTime? COMPLETE_DATE { get; set; }

        [StringLength(1)]
        public string PUBLISH_STATE { get; set; }

        public int? IS_DOWN { get; set; }

        public DateTime? PUBLISH_DATE { get; set; }

        public DateTime? ACTUAL_BEGIN_DATE { get; set; }

        public DateTime? ACTUAL_END_DATE { get; set; }

        public int? WORK_DATE { get; set; }

        [StringLength(50)]
        public string OP_PID { get; set; }

        [StringLength(50)]
        public string OP_GID { get; set; }

        [StringLength(50)]
        public string OP_CODE { get; set; }

        public int? OP_FLAG { get; set; }

        public int? PLAN_OP_SEQ { get; set; }

        public int? ACTUAL_OP_SEQ { get; set; }

        public int? EFFECTIVE_QTY { get; set; }

        public int? UNEFFECTIVE_QTY { get; set; }

        public int? DISCARD_QTY { get; set; }

        public int? TRANS_QTY { get; set; }

        public int? WORK_ORDER_FLAG { get; set; }

        [StringLength(20)]
        public string CHK_ID { get; set; }

        public DateTime? CHK_DATE { get; set; }

        [StringLength(50)]
        public string LABOUR_GROUP_GID { get; set; }

        [StringLength(50)]
        public string FEATURE_LOT_CODE { get; set; }

        [StringLength(200)]
        public string REMARK { get; set; }

        public int? QUALITY_STATE { get; set; }

        public int? IS_LAST { get; set; }

        public int? SEQ { get; set; }

        public int? IS_FREEZE { get; set; }

        public int? REQ_NUM { get; set; }

        public int? IS_CLOSE { get; set; }

        public int? IS_SPLIT { get; set; }

        [StringLength(50)]
        public string PARENT_GID { get; set; }

        public int? SOURCE { get; set; }

        [StringLength(100)]
        public string SOURCE_CODE { get; set; }

        [Column(TypeName = "datetime2")]
        public DateTime CREATE_DATE { get; set; }

        [Required]
        [StringLength(32)]
        public string CREATE_ID { get; set; }

        [StringLength(32)]
        public string MODIFY_ID { get; set; }

        [Column(TypeName = "datetime2")]
        public DateTime? MODIFY_DATE { get; set; }

        public int IS_ACTIVE { get; set; }

        public int IS_DELETE { get; set; }

        [StringLength(32)]
        public string SITE { get; set; }

        [StringLength(50)]
        public string UDA1 { get; set; }

        [StringLength(50)]
        public string UDA2 { get; set; }

        [StringLength(50)]
        public string UDA3 { get; set; }

        [StringLength(50)]
        public string UDA4 { get; set; }

        [StringLength(50)]
        public string UDA5 { get; set; }

        [StringLength(100)]
        public string UDA1C { get; set; }

        [StringLength(100)]
        public string UDA1N { get; set; }

        [StringLength(100)]
        public string UDA2C { get; set; }

        [StringLength(100)]
        public string UDA2N { get; set; }

        [StringLength(100)]
        public string UDA3C { get; set; }

        [StringLength(100)]
        public string UDA3N { get; set; }

        [StringLength(100)]
        public string UDA4C { get; set; }

        [StringLength(100)]
        public string UDA4N { get; set; }

        [StringLength(100)]
        public string UDA5C { get; set; }

        [StringLength(100)]
        public string UDA5N { get; set; }

        public int? STATE { get; set; }
    }
}
